USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[FlagInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.FlagInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 09/05/08
-- Description:	Flag Table Insert
-- =============================================
CREATE PROCEDURE FlagInsert

           @FlagId int
           ,@PlayerId varchar(30)
           ,@DateTime datetime
           ,@Flag_x float
           ,@Flag_y float
           ,@Flag_z float
           ,@FlagEventId int
           ,@LogId int
           ,@MapId int
           ,@RoundId int
           ,@MiniRoundId int
AS
BEGIN

INSERT INTO [AnotherSuccessfulProcedure].[dbo].[Flag]
           ([FlagId]
           ,[PlayerId]
           ,[DateTime]
           ,[Flag_x]
           ,[Flag_y]
           ,[Flag_z]
           ,[FlagEventId]
           ,[LogId]
           ,[MapId]
           ,[RoundId]
           ,[MiniRoundId])
     VALUES
           (@FlagId
           ,@PlayerId
           ,@DateTime
           ,@Flag_x
           ,@Flag_y
           ,@Flag_z
           ,@FlagEventId
           ,@LogId
           ,@MapId
           ,@RoundId
           ,@MiniRoundId)

END
GO
